BI-Uday-Naveen-Dhananjay - 2016-07-01 - 27652 - Spec - BW on HANA - (Lorenz Gan by 2017-12-24) #hold

SPECIFICATIONS

27652- BW on HANA

Purpose


Need to migrate current BW Database to HANA (BW On HANA).

Admin Info


Purpose
Need to migrate Current BW Database to HANA (BW On HANA)
Requested By
Lorenz Gan
Spec Created By
Naveen Gadde
Spec Created Date
07/01/2016
Spec QA by
Uday Kumar P
Objects
BPD, BPQ and BPP
Document Status
WIP

Estimates


SNo
Activity
Estimation in Hours
1
Research
10
2
Documentation
04
3
Development/ Config
32
4
Unit test in DEV
08
5
Unit test in QUA
08
6
Transport management
08

TOTAL
70

References


Prior Tickets

27320

Documents


SAP Notes
0001847431.pdf
0001736976.pdf
0001729988.pdf

Process Procedure Documents:
SAP_BW_ABAP_Analyzer_v4_1_Doc.pdf
SAP_BW_HANA_Checklist_v4_1_Doc.pdf
SAP_BW_on_HANA_Sizing_V2_1_6.pdf

BPD Results:
HANA-Sizing-BPD.pdf
BW HANA Checklist -BPD.pdf
BW ABAP Routine-Analyzer-BPD.pdf

BPQ Results:
HANA-Sizing-BPQ.pdf
BW HANA checklist -BPQ.pdf
BW ABAP Routine-Analyzer-BPQ.pdf

BPP Results:
HANA-Sizing-BPP.pdf
BW HANA Checklist - BPP.pdf
BW ABAP Routine-Analyzer-BPP.pdf


Spec Changes


SNo
Change Details
Requested By
Requested On
Notes if any

























Functional Requirement


Purpose/WHY:

Email From Mark Harris On 07/15/2016:
We are preparing for the BW shift to HANA by the end of the year. There are some notes to follow for sizing and preparedness information.
Can you guys take a look at this and run them for me? I think we already did the sizing so we don’t need that again if it’s the same one you ran last time.

1. Database Size - IMPORTANT
Please run and provide the output file from the latest version of the BW on HANA sizing script in SAP Note 1736976 to obtain database size of the productive SAP BW instance.

2. BW Checklist Tool - IMPORTANT
Please run and provide the output file from the BW on HANA checklist tool program in OSS Note 1729988. This will allow us to obtain open and outstanding items required for the upgrade & migration.

3. SAP BW ABAP Routine Analyzer
Please run and provide the output file from the BW on HANA ABAP Routine Analyzer program as documented in OSS Note 1847431."

In Scope:

BPD, BPQ and BPP.

Out of Scope:

None

Solution Summary


1. As a prerequisite, we need to analyze & run the HANA checklist tools, database sizing and ABAP Routine analyzer in BPD.
2. Need to collect the statistics from all the above tools.
3. Need to fix the identified issues manually & implement SAP notes for any other standard issues.
4. Need to fix all the issues before the system is ready for HANA Migration
5. Need to migrate current BW Database to HANA Database (BW on HANA).
6. Need to collect these changes into transports and move them to BPQ & BPP.
6. Need to transport the SAP specified programs created in BPD to BPQ & BPP
7. Need to run the programs in BPQ, BPP & fix the identified issues.

Solution Details


1. As a prerequisite, we need to analyze & run the HANA checklist tools, database sizing and ABAP Routine analyzer in BPD.
2. Need to collect the statistics from all the above tools.
3. Need to fix the identified issues manually & implement SAP notes for any other standard issues.
4. Need to fix all the issues before the system is ready for HANA Migration
5. Need to migrate current BW Database to HANA Database (BW on HANA).
6. Need to collect these changes into transports and move them to BPQ & BPP.
6. Need to transport the SAP specified programs created in BPD to BPQ & BPP
7. Need to run the programs in BPQ, BPP & fix the identified issues.

Issues


The output of the programs is suggested to be in HTML format but due to the file content and size of file, need to convert from HTML to PDF format.